IF exists(SELECT * FROM dbo.sysobjects WHERE name='vulaccount' AND xtype='P') 
BEGIN
	DROP PROCEDURE vulaccount
END
GO

create procedure vulaccount
as
delete from accounts
insert into accounts(naamcode,geboortedatum)
select l.naamcode,a.geboortedatum from
leraars..leraars as l left join 
leraars..administratie as a
on l.naamcode=a.naamcode